 

<jsp:directive.page import="java.sql.*"/>
<jsp:directive.page import="Connectivity.ConnectionManager"/>
 <%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
String Activity = request.getParameter("Activity")!=null?request.getParameter("Activity"):"2";
 

%>
   <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
   "http://www.w3.org/TR/html4/loose.dtd">

   <html>

      <head>
         <meta http-equiv="Content-Type" 
            content="text/html; charset=windows-1256">
         <title>   Header </title>
      </head>
 
 



	
  </SCRIPT>
      
<body bgcolor="white" >
<table border=1 width=100% height=100%>
<tr><td>
<table align=right height=20% width=100% >
			<tr>
			  <td align=right><%=(session.getAttribute("firm_name"))%></td>
			 <td align=right><img src="<%=basePath%>images\Company.jpg" height=119 width=109></td> 
			 </tr>
			</table>

 </tr></td>
 <tr><td><marquee>welcome <%=(session.getAttribute("uname")) %></marquee>

 </td></tr>
 
 <tr><td>
 <table width=100% height=80%>
 <tr >
 <table id=Employee align=left border=1  width=20% cellspacing="20" cellpadding="8">
 <%
 int role_id=Integer.parseInt(""+(session.getAttribute("role_id")));
 String mainimage=null,maindesc=null;
 Connection con=null;
 PreparedStatement prst=null,prst1=null;
		String firm_id=null,firm_name=null,firm_city=null,firm_image=null;
	try
	{	
		con=ConnectionManager.getConnection();
  
	String querry="select mlm.main_link_id,mlm.main_link_desc,mlm.main_link_information,trim(mlm.main_link_image_location)as image_path ";
	 querry=querry+"from access_control_list acl JOIN main_link_master mlm ON (acl.main_link_id=mlm.main_link_id and  mlm.status='V' and acl.role_id="+role_id+") ";
     querry=querry+"group by mlm.main_link_desc,mlm.main_link_information,trim(mlm.main_link_image_location),mlm.main_link_id,mlm.order_id ";
     querry=querry+"order by mlm.order_id ";
	 prst=con.prepareStatement(""+querry);
	    ResultSet rs=prst.executeQuery();
	    if(rs.equals(null))
	  {
 
out.println(" Error");
 		
 	   }
 	   else
 	   { int cnt=1;
 	   while(rs.next())
 	   {
if(Activity.equals(rs.getString(1)))
{
mainimage=rs.getString(4);
maindesc=rs.getString(3);

}
  %>
  
<tr><td align="center">
<a href='/Genius/form/general/userLogged.jsp?Activity=<%=rs.getString(1)%>'><%=rs.getString(2)%></a></td></tr>
<%}

} %>

</tr>
<tr><td align="center">
<a href='/Genius/form/general/Login.jsp'>Logout</a></td></tr>

  
 
</tr>
</tr>   
<%
}
catch(Exception e)
{e.printStackTrace();}

 %> </tr></table>

      </body>
	
   </html>